Overview

Our group endeavors to demystify the intricacies of the New York City housing landscape, providing a thorough analysis that spans the diverse boroughs and neighborhoods of this vibrant metropolis. Utilizing a rich dataset, we aim to unravel the variegated tapestry of real estate prices, offering insights that cater to potential homebuyers, sellers, and market enthusiasts alike.

Topic: The relationship between size of the house, #of bedrooms, #of bathrooms and its price.

Topic: What are the incremental average price contributions for each house type?

Topic: How do house prices vary by type? Which house type is most expensive/cheap?

The Number of Retail Establishment by Zip Codes

This interactive leaflet map is a choropleth map which is shaded with the number of retail establishment in each USPS zip codes blocks. The color scheme is from bright yellow to dark purple, which brighter color indicate more retails. This visualization provides an overview of New York City’s retail activity on a smaller spectrum–by neighborhood. The interactive feature allow users could zoom in and select specific neighborhoods to check the exact number of retailers.

Topic: Will the presence of more retail store lead to higher housing price in the neighborhood?

Property Type Counts:

This bar chart titled “Property Type Counts” showcases the frequency of different property types available for sale. At first glance, it’s apparent that the most common type is the ‘House for sale’, towering over the others with the highest count. Following that, ‘Condo for sale’ and ‘Multi-family home for sale’ are also quite prevalent in the market. On the lower end of the spectrum, there are categories like ‘Mobile home for sale’ and ‘Pending home for sale’, which are less numerous.

We find it interesting to note the diversity of property types, indicating a vibrant and varied real estate market. This chart effectively communicates the breakdown of property types, providing a clear visual representation that can be easily interpreted at a glance. It’s a useful tool for quickly assessing which types of properties dominate the market and could inform decisions for both real estate professionals and potential buyers.

Topic: Impact of Broker Influence on Property Values Across Different Square Footages

In this scatter plot, we’ve visualized the relationship between house prices and property square footage, as managed by different real estate brokers. Each point on the graph represents a property, with the horizontal axis showing its size in square feet and the vertical axis showing its price. The color of each point corresponds to a specific broker, allowing me to see at a glance how the property size relates to its price across various brokers.

From this graph, we can observe that certain brokers, like those represented by the clusters of points towards the bottom, have a range of properties at varying sizes and prices, while others may specialize more in either higher or lower-priced markets, regardless of the size. For instance, some brokers seem to handle more expansive properties, as indicated by the larger square footage values, while others have properties that are smaller but vary widely in price.

By making this plot interactive with plotly, we enable the viewer to hover over individual points to get more detailed information, such as the exact size, price, and the broker listing the property. This level of interactivity makes the plot a powerful tool for interactive data exploration and provides valuable insights into the real estate market’s pricing strategies from a broker.

Topic: House Price Range Distribution Across Top and Bottom Brokers

Here we have a heatmap titled “House Price Distribution Heatmap by Broker,” which I’ve created to analyze and visualize the property pricing strategies of different real estate brokers. This chart categorizes properties based on their price range, displayed on the y-axis, and the corresponding brokers on the x-axis.

Each cell’s color intensity reflects the number of properties that fall within a specific price range for a given broker. Darker shades of blue indicate a higher concentration of properties within a price range, as denoted by the color scale on the right. For example, you can see that some brokers have a higher concentration of properties in particular price ranges, shown by the dark blue tiles.

This visual representation allows me to quickly identify patterns and outliers in the pricing strategies of these brokers. It’s clear that some brokers tend to handle properties within a narrower price range, while others have listings spread across a broader spectrum of prices. This insight could be pivotal for potential buyers who are targeting specific price ranges, as well as for market analysts interested in the competitive positioning of brokers in the real estate market.